Click the ADO and OLE DB option in the Select Data Source dialog box. This option is designed to allow you to specify an ADO connection string that can connect to any OLE DB provider.
Type the ADO connection string into the text box provided, or click Build to open the Datal Links Properties dialog box. The following are examples of an acceptable connection string for ADO:
DSN=Xtreme sample data;
DATABASE=pubs;DSN=Publishers;UID=sa;Password=;
Type in the first example shown here to follow along in this tutorial. Click Next in the Select Data Source dialog box when finished. The Select Recordset dialog box appears.
Determine if you want to create a Recordset using an object available from your data source, such as a database table, or if you prefer to specify a SQL statement. Select the appropriate option in the Recordset section of the Select Recordset dialog box.
If you want to connect to a database object, use the Object Type drop-down list to select the type of database object, such as a Table, then select the object itself from the Object drop-down list.
If you want to obtain a Recordset using a SQL statement, write the SQL statement in the text box provided, or click Build to use the Microsoft Query application and Query Wizard to visually design your SQL statement.
Click Finish in the Select Recordset dialog box. You will see ado in the list box on the Data Tab of the Standard Report Expert.
Continue creating your report normally. While creating your report, the ado specification will act like a database table, providing all fields that have been obtained from your ADO Recordset.